{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Questionnaire Generator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Questionnaire Generator","index":0,"n_rows":55,"n_cols":17,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Module 1. Quality Assurance","Module 2. Overview of HIV Rapid Testing","Module 3. Safety at the HIV Testing Site","Module 4. Specimen Handling and storage","Module 5. HIV Testing Algorithm","Module 6. Record Keeping - Logbook","EQA and DTS PT ","Module 8. Professional Ethics",null,null,null,null,"Section Name","Group Name","N: Total Number of Questions","k: Number of questions Needed","Questions for the Random version"]
["Question Code","Question Code","Question Code","Question Code","Question Code","Question Code","Question Code","Question Code",null,null,null,null,"Section 1.","Quality Asurance",19,3,"Question 1-4 , Question 1-5 , Question 1-15"]
["1-1","2-1","3-1","4-1","5-1  ","6-1","7-1","8-1",null,null,null,null,"Section 2.","HIV RT Overview",17,3,"Question 2-16 , Question 2-5 , Question 2-4"]
["1-2","2-2","3-2","4-2","5-2","6-2","7-2","8-2",null,null,null,null,"Section 3.","Safety",40,3,"Question 3-4 , Question 3-20 , Question 3-13"]
["1-3","2-3","3-3","4-3","5-3","6-3","7-3","8-3",null,null,null,null,"Section 4.","Specimen Collection",19,2,"Question 4-1 , Question 4-6"]
["1-4","2-4","3-4","4-4","5-4","6-4","7-4","8-4",null,null,null,null,"Section 5.","HIV Testing Algorithm",18,3,"Question 5-11 , Question 5-16 , Question 5-3"]
["1-5","2-5","3-5","4-5","5-5","6-5","7-5","8-5",null,null,null,null,"Section 6.","Record Keeping",18,3,"Question 6-1 , Question 6-9 , Question 6-17"]
["1-6","2-6","3-6","4-6","5-6","6-6","7-6","8-6",null,null,null,null,"Section 7.","EQA and DTS PT",20,4,"Question 7-16 , Question 7-18 , Question 7-17 , Question 7-11"]
["1-7","2-7","3-7","4-7","5-7","6-7","7-7","8-7",null,null,null,null,"Section 8.","Professional Ethic",16,2,"Question 8-7 , Question 8-14"]
["1-8","2-8","3-8","4-8","5-8","6-8","7-8","8-8",null,null,null,null,"Section 9.","Inventory",21,2,"Question 9-14 , Question 9-5"]
["1-9","2-9","3-9","4-9","5-9","6-9","7-9","8-9",null,null,null,null,null,"TOTAL",{"$f":"SUM(O2:O10)","v":188},{"$f":"SUM(P2:P10)","v":25}]
[]
["1-10","2-10","3-10","4-10","5-10","6-10","7-10","8-10"]
["1-11","2-11","3-11","4-11","5-11","6-11","7-11","8-11"]
["1-12","2-12","3-12","4-12","5-12","6-12","7-12","8-12"]
["1-13","2-13","3-13","4-13","5-13","6-13","7-13","8-13"]
["1-14","2-14","3-14","4-14","5-14","6-14","7-14","8-14"]
["1-15","2-15","3-15","4-15","5-15","6-15","7-15","8-15"]
["1-16","2-16","3-16","4-16","5-16","6-16","7-16","8-16"]
["1-17","2-17","3-17","4-17","5-17","6-17","7-17","8-17"]
["1-18","2-18","3-18","4-18","5-18","6-18","7-18","8-18"]
["1-19",null,"3-19","4-19","5-19","6-19","7-19","8-19"]
["1-20",null,"3-20",null,"5-20","6-20",null,"8-20"]
["1-21",null,"3-21",null,"5-21","6-21"]
[null,null,"3-22",null,"5-22"]
[null,null,"3-23"]
[null,null,"3-24"]
[null,null,"3-25"]
[null,null,"3-26"]
[null,null,"3-27"]
[null,null,"3-28"]
[null,null,"3-29"]
[null,null,"3-30"]
[null,null,"3-31"]
[null,null,"3-32"]
[null,null,"3-33"]
[null,null,"3-34"]
[null,null,"3-35"]
[null,null,"3-36"]
[null,null,"3-37"]
[null,null,"3-38"]
[null,null,"3-39"]
[null,null,"3-40"]
["N=21","N=18","N=40","N=19","N=22","N=21","N=19","N=20"]
[]
[]
["Group Name","N: Total Number of Questions","k: Number of questions Needed","Nombre de combinaisons uniques possibles (K questions differentes parmi N questions) ","Nombre de combinaisons NON uniques possibles (K questions differentes parmi N questions) "]
["Quality Asurance",21,3,{"$f":"FACT($B48) / (FACT($B48-$C48) *FACT($C48))","v":1330},{"$f":"21*20*19","v":7980}]
["HIV RT Overview",18,4,{"$f":"FACT($B49) / (FACT($B49-$C49) *FACT($C49))","v":3060},{"$f":"18*17*16*15","v":73440}]
["Safety",40,3,9880.0000000000018,{"$f":"40*39*38*37","v":2193360}]
["Specimen Collection",19,2,171,{"$f":"19*18*17","v":5814}]
["HIV Testing Algorithm",22,4,7315,{"$f":"22*21*20*19","v":175560}]
["Record Keeping",21,3,1330,{"$f":"21*20*19","v":7980}]
["EQA and DTS PT",19,4,3876,{"$f":"19*18*17*16","v":93024}]
["Professional Ethic",20,2,190,{"$f":"20*19","v":380}]